import pandas as pd
# Define the columns and their descriptions
columns_data = [
("year", "The year of the financial data.", "General Information"),
("fiscalDateEnding_balance", "The date when the balance sheet data ends.", "Balance Sheet"),
("reportedCurrency_balance", "Currency in which balance sheet data is reported (e.g., USD, EUR).", "Balance Sheet"),
("totalAssets", "Total value of everything the company owns (e.g., cash, buildings, equipment).", "Balance Sheet"),
("totalCurrentAssets", "Assets that can be quickly converted into cash, typically within a year.", "Balance Sheet"),
("cashAndCashEquivalentsAtCarryingValue", "Cash and short-term investments that are as good as cash.", "Balance Sheet"),
("cashAndShortTermInvestments", "Cash and investments that can be easily converted into cash.", "Balance Sheet"),
("inventory", "The value of goods the company plans to sell in the near future.", "Balance Sheet"),
("currentNetReceivables", "Money that customers owe to the company but has not been paid yet.", "Balance Sheet"),
("totalNonCurrentAssets", "Long-term assets that cannot be quickly converted to cash.", "Balance Sheet"),
("propertyPlantEquipment", "Physical assets like buildings or machinery used for business operations.", "Balance Sheet"),
("accumulatedDepreciationAmortizationPPE", "The total reduction in the value of physical assets due to wear and tear.", "Balance Sheet"),
("intangibleAssets", "Non-physical assets like patents, trademarks, or copyrights.", "Balance Sheet"),
("goodwill", "Extra value paid when acquiring a company, beyond its tangible assets.", "Balance Sheet"),
("investments", "Money invested in other companies or ventures.", "Balance Sheet"),
("longTermInvestments", "Investments that are expected to be held for more than a year.", "Balance Sheet"),
("shortTermInvestments", "Investments that can be easily turned into cash within a year.", "Balance Sheet"),
("otherCurrentAssets", "Miscellaneous assets that are expected to be converted into cash soon.", "Balance Sheet"),
("otherNonCurrentAssets", "Other long-term assets not categorized elsewhere.", "Balance Sheet"),
("totalLiabilities", "Total amount of money the company owes to others.", "Balance Sheet"),
("totalCurrentLiabilities", "Debts or obligations that must be settled within a year.", "Balance Sheet"),
("currentAccountsPayable", "Money the company owes to suppliers or creditors.", "Balance Sheet"),
("deferredRevenue", "Payments received for goods or services that have not yet been delivered.", "Balance Sheet"),
("currentDebt", "Short-term borrowings that need to be paid within a year.", "Balance Sheet"),
("shortTermDebt", "Loans or debts that are due within a year.", "Balance Sheet"),
("totalNonCurrentLiabilities", "Long-term debts or obligations that are not due soon.", "Balance Sheet"),
("capitalLeaseObligations", "Long-term rental agreements for the use of assets.", "Balance Sheet"),
("longTermDebt", "Debt that is due for payment after more than a year.", "Balance Sheet"),
("treasuryStock", "The companys own stock that it has repurchased but not canceled.", "Balance Sheet"),
("retainedEarnings", "Profits the company has kept instead of paying them out as dividends.", "Balance Sheet"),
("commonStock", "Shares issued to shareholders in exchange for ownership in the company.", "Balance Sheet"),
("commonStockSharesOutstanding", "The total number of shares currently held by shareholders.", "Balance Sheet"),
("fiscalDateEnding_income", "The date when the income statement data ends.", "Income Statement"),
("reportedCurrency_income", "Currency in which income statement data is reported.", "Income Statement"),
("grossProfit", "Revenue minus the cost of goods sold.", "Income Statement"),
("totalRevenue", "Total income generated from all business activities.", "Income Statement"),
("costOfRevenue", "Costs directly tied to producing goods and services.", "Income Statement"),
("costofGoodsAndServicesSold", "Cost of producing the goods or services the company sells.", "Income Statement"),
("operatingIncome", "Profit from the companys main business operations.", "Income Statement"),
("sellingGeneralAndAdministrative", "Costs related to selling and managing the business.", "Income Statement"),
("researchAndDevelopment", "Expenditures for developing new products or services.", "Income Statement"),
("operatingExpenses", "Total expenses from running the business operations.", "Income Statement"),
("investmentIncomeNet", "Income earned from investments.", "Income Statement"),
("netInterestIncome", "Income earned from interest, minus interest expenses.", "Income Statement"),
("interestIncome", "Money earned from lending or investing.", "Income Statement"),
("interestExpense", "The cost of borrowing money.", "Income Statement"),
("nonInterestIncome", "Income earned without interest, like fees or royalties.", "Income Statement"),
("otherNonOperatingIncome", "Income from activities not related to the core business.", "Income Statement"),
("depreciation", "The reduction in value of physical assets over time.", "Income Statement"),
("depreciationAndAmortization", "Total depreciation of physical assets and amortization of intangible assets.", "Income Statement"),
("incomeBeforeTax", "Income before any taxes are deducted.", "Income Statement"),
("incomeTaxExpense", "Taxes the company owes based on its income.", "Income Statement"),
("interestAndDebtExpense", "Total costs related to borrowing and interest payments.", "Income Statement"),
("netIncomeFromContinuingOperations", "Profit from ongoing business activities, after expenses and taxes.", "Income Statement"),
("comprehensiveIncomeNetOfTax", "Total income after taxes, including unusual gains or losses.", "Income Statement"),
("ebit", "Earnings before interest and taxes; a measure of operating profit.", "Income Statement"),
("ebitda", "Earnings before interest, taxes, depreciation, and amortization; shows operating profitability.", "Income Statement"),
("netIncome", "The companys total profit after all expenses and taxes.", "Income Statement"),
("fiscalDateEnding", "The date when the cash flow data ends.", "Cash Flow Statement"),
("reportedCurrency", "Currency in which cash flow data is reported.", "Cash Flow Statement"),
("operatingCashflow", "Cash generated by the company from its main business activities.", "Cash Flow Statement"),
("paymentsForOperatingActivities", "Cash used for the companys core operations.", "Cash Flow Statement"),
("proceedsFromOperatingActivities", "Cash received from the companys core operations.", "Cash Flow Statement"),
("changeInOperatingLiabilities", "The increase or decrease in the company's short-term obligations.", "Cash Flow Statement"),
("changeInOperatingAssets", "The increase or decrease in the companys short-term assets.", "Cash Flow Statement"),
("depreciationDepletionAndAmortization", "Cash flow impact from reducing the value of physical and intangible assets.", "Cash Flow Statement"),
("capitalExpenditures", "Cash spent on buying or improving physical assets like buildings or equipment.", "Cash Flow Statement"),
("changeInReceivables", "Changes in money owed to the company by customers.", "Cash Flow Statement"),
("changeInInventory", "Changes in the amount of inventory held by the company.", "Cash Flow Statement"),
("profitLoss", "The net result of the companys financial activities; profit or loss.", "Cash Flow Statement"),
("cashflowFromInvestment", "Cash flow related to buying or selling investments.", "Cash Flow Statement"),
("cashflowFromFinancing", "Cash flow from borrowing money, issuing shares, or paying dividends.", "Cash Flow Statement"),
("proceedsFromRepaymentsOfShortTermDebt", "Money received from repaying short-term borrowings.", "Cash Flow Statement"),
("paymentsForRepurchaseOfCommonStock", "Cash spent to buy back the companys own shares.", "Cash Flow Statement"),
("paymentsForRepurchaseOfEquity", "Cash spent to repurchase shares or ownership.", "Cash Flow Statement"),
("paymentsForRepurchaseOfPreferredStock", "Cash used to buy back preferred stock from shareholders.", "Cash Flow Statement"),
("dividendPayout", "Cash paid to shareholders as dividends.", "Cash Flow Statement"),
("dividendPayoutCommonStock", "Dividends paid on common shares.", "Cash Flow Statement"),
("dividendPayoutPreferredStock", "Dividends paid on preferred shares.", "Cash Flow Statement"),
("proceedsFromIssuanceOfCommonStock", "Cash received from issuing new common shares.", "Cash Flow Statement"),
("proceedsFromIssuanceOfLongTermDebtAndCapitalSecuritiesNet", "Cash received from issuing long-term debt or securities.", "Cash Flow Statement"),
("proceedsFromIssuanceOfPreferredStock", "Cash raised from issuing preferred stock.", "Cash Flow Statement"),
("proceedsFromRepurchaseOfEquity", "Cash received from repurchasing equity.", "Cash Flow Statement"),
("proceedsFromSaleOfTreasuryStock", "Cash from selling stock that was repurchased earlier.", "Cash Flow Statement"),
("changeInCashAndCashEquivalents", "Change in cash and cash equivalents from one period to the next.", "Cash Flow Statement"),
("changeInExchangeRate", "Change in cash due to currency exchange rates.", "Cash Flow Statement"),
("cashAndCashEquivalentsPeriodEnd", "Amount of cash and equivalents at the end of the period.", "Cash Flow Statement"),
]
# Convert the data into a DataFrame for better viewing
df_data_dict = pd.DataFrame(columns_data, columns=["Column", "Description", "Section"])
